IPS database create srcript

CREATE TABLE events
(
   eventid numeric NOT NULL, 
   vendor text, 
   severity text, 
   originator text, 
   "time" timestamp with time zone, 
   signature_description text, 
   signature_id integer, 
   signature_subsigid integer, 
   signature_version text, 
   signature_sigdetails text, 
   participants_attacker_addr inet, 
   participants_attacker_port integer, 
   participants_target_addr inet, 
   participants_target_port integer, 
   protocol text,
   CONSTRAINT pk_eventid PRIMARY KEY (eventid)
) WITH (OIDS=FALSE);

Cisco IDS database create script

CREATE TABLE events
(
   "index" bigserial NOT NULL,
   eventid numeric NOT NULL,
   vendor text,
   severity text,
   originator text,
   "time" timestamp with time zone,
   signature_description text,
   signature_id integer,
   signature_subsigid integer,
   signature_version text,
   signature_sigdetails text,
   signature_marscategory text,
   interfacegroup text,
   vlan integer,
   participants_attacker_addr inet,
   participants_attacker_port integer,
   participants_attacker_locality text,
   participants_target_addr inet,
   participants_target_port integer,
   participants_target_locality text,
   context_fromattacker text,
   alertdetails text,
   alertdetails_slotnum integer,
   alertdetails_subslotnum integer,
   alertdetails_portnum integer,
   alertdetails_subintnum integer,
   alertdetails_inttype integer,
   riskratingvalue integer,
   riskratingvalue_targetvaluerating text,
   riskratingvalue_attackrelevancerating text,
   threatratingvalue integer,
   ids_interface text,
   protocol text,
   CONSTRAINT pk_index PRIMARY KEY (index)
) WITH (OIDS=FALSE);
